<Page id="1" templateExtension="html" relativePath="." fullRelativePath="." secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Aqua" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="10" connection="projectkar" name="ITEM_USER" pageSizeLimit="100" wizardCaption="List of ITEM, &quot; USER&quot; " wizardTheme="Aqua" wizardThemeType="File" wizardGridType="Columnar" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="True" dataSource="SELECT ITEM.ID AS ITEM_ID,ITEM.NAME AS ITEM_NAME,ITEM.MONEY,item.crt_date, &quot;USER&quot;.NAME AS OWNER, ITEM_CATEGORY.NAME AS ITEM_CATEGORY_NAME 
FROM ITEM,&quot;USER&quot;,ITEM_CATEGORY,
         (select ite_id,count(buyed.id) num 
         from buyed
         group by ite_id
       ) num_buyed
WHERE (ITEM.USE_ID = &quot;USER&quot;.ID) 
AND (ITEM.ITE_ID = ITEM_CATEGORY.ID) 
AND (num_buyed.ite_id(+)=item.id) 
AND ( ITEM.NAME LIKE '%{ITEM_NAME}%'
  AND ITEM_CATEGORY.NAME LIKE '%{ITEM_CATEGORY_NAME}%'
  AND &quot;USER&quot;.USERNAME LIKE '%{USERNAME}%'
  AND nvl(num_buyed.num,0)&gt;={NUM_BUYED}
)" activeCollection="SQLParameters" activeTableType="dataSource" parameterTypeListName="ParameterTypeList">
			<Components>
				<Link id="59" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="ITEM_NAME" wizardTheme="Aqua" wizardThemeType="File" fieldSource="ITEM_NAME" hrefSource="see_software_detail.ccp">
<Components/>
<Events/>
<LinkParameters>
<LinkParameter id="60" sourceType="DataField" name="ITEM_ID" source="ITEM_ID"/>
</LinkParameters>
</Link>
<Label id="12" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="CRT_DATE" fieldSource="CRT_DATE" wizardCaption="CRT DATE" wizardTheme="Aqua" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="13" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="MONEY" fieldSource="MONEY" wizardCaption="MONEY" wizardTheme="Aqua" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="14" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="USER_NAME" fieldSource="OWNER" wizardCaption="USER NAME" wizardTheme="Aqua" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Navigator id="15" name="Navigator" wizardPagingType="ImageButtons" wizardFirst="False" wizardFirstText="First" wizardPrev="True" wizardPrevText="Prev" wizardNext="True" wizardNextText="Next" wizardLast="False" wizardLastText="Last" wizardImages="True" wizardSize="10" wizardTotalPages="False" wizardHideDisabled="False" wizardOfText="of" wizardTheme="Aqua" wizardThemeType="File" wizardImagesScheme="Aqua" type="Simple">
					<Components/>
					<Events/>
				</Navigator>
			</Components>
			<Events/>
			<TableParameters>
				<TableParameter id="21" conditionType="Parameter" useIsNull="True" field="ITEM.NAME" dataType="Text" searchConditionType="Contains" parameterType="URL" logicOperator="And" parameterSource="ITEM_NAME" orderNumber="1"/>
				<TableParameter id="30" conditionType="Parameter" useIsNull="True" field="ITEM_CATEGORY.NAME" dataType="Text" searchConditionType="Contains" parameterType="URL" logicOperator="And" parameterSource="ITEM_CATEGORY_NAME" orderNumber="2"/>
				<TableParameter id="31" conditionType="Parameter" useIsNull="True" field="&quot;USER&quot;.USERNAME" dataType="Text" searchConditionType="Contains" parameterType="URL" logicOperator="And" parameterSource="USERNAME" orderNumber="3"/>
				<TableParameter id="32" conditionType="Parameter" useIsNull="True" field="ITEM.CRT_DATE" dataType="Date" searchConditionType="GreaterThan" parameterType="URL" logicOperator="And" parameterSource="CRT_DATE" orderNumber="4"/>
				<TableParameter id="54" conditionType="Parameter" useIsNull="False" field="NAME" parameterSource="s_NAME" dataType="Text" logicOperator="And" searchConditionType="Contains" parameterType="URL" orderNumber="1"/>
				<TableParameter id="55" conditionType="Parameter" useIsNull="False" field="DESCRIPTION" parameterSource="s_DESCRIPTION" dataType="Text" logicOperator="And" searchConditionType="Contains" parameterType="URL" orderNumber="2"/>
				<TableParameter id="56" conditionType="Parameter" useIsNull="False" field="USE_ID" parameterSource="s_USE_ID" dataType="Float" logicOperator="And" searchConditionType="Equal" parameterType="URL" orderNumber="3"/>
				<TableParameter id="57" conditionType="Parameter" useIsNull="False" field="CRT_DATE" parameterSource="s_CRT_DATE" dataType="Date" logicOperator="And" searchConditionType="Equal" parameterType="URL" orderNumber="4"/>
				<TableParameter id="58" conditionType="Parameter" useIsNull="False" field="MONEY" parameterSource="s_MONEY" dataType="Float" logicOperator="And" searchConditionType="Equal" parameterType="URL" orderNumber="5"/>
			</TableParameters>
			<JoinTables>
				<JoinTable id="41" tableName="ITEM" posWidth="156" posHeight="261" posLeft="10" posTop="10"/>
				<JoinTable id="43" tableName="&quot;USER&quot;" posWidth="100" posHeight="100" posLeft="192" posTop="32"/>
				<JoinTable id="45" tableName="ITEM_CATEGORY" posWidth="100" posHeight="100" posLeft="320" posTop="147"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="47" fieldLeft="ITEM.USE_ID" fieldRight="&quot;USER&quot;.ID" tableLeft="ITEM" tableRight="&quot;USER&quot;" conditionType="Equal" joinType="inner"/>
				<JoinTable2 id="48" fieldLeft="ITEM.ITE_ID" fieldRight="ITEM_CATEGORY.ID" tableLeft="ITEM" tableRight="ITEM_CATEGORY" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="42" tableName="ITEM" alias="ITEM_NAME" fieldName="ITEM.NAME"/>
				<Field id="44" tableName="&quot;USER&quot;" fieldName="&quot;USER&quot;.*"/>
				<Field id="46" tableName="ITEM_CATEGORY" alias="ITEM_CATEGORY_NAME" fieldName="ITEM_CATEGORY.NAME"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="49" variable="ITEM_NAME" parameterType="URL" dataType="Text" parameterSource="ITEM_NAME"/>
				<SQLParameter id="50" variable="ITEM_CATEGORY_NAME" parameterType="URL" dataType="Text" parameterSource="ITEM_CATEGORY_NAME"/>
				<SQLParameter id="51" variable="USERNAME" parameterType="URL" dataType="Text" parameterSource="USERNAME"/>
				<SQLParameter id="53" variable="NUM_BUYED" parameterType="URL" defaultValue="0" dataType="Integer" parameterSource="NUM_BUYED" format="0;(0)"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="search_software.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="search_software.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="search_software.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="search_softwareHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
